A Quick Glance

  • black-arrow

    Work efficiently with MS Excel 2016 and its latest features

  • black-arrow

    Find what’s new in MS Excel 2016

  • black-arrow

    Printing of a workbook

  • black-arrow

    Handling with date formats

  • black-arrow

    Review Excel terminologies

  • black-arrow

    How to use VLOOKUP and HLOOKUP

  • black-arrow

    Use cell themes and styles

  • black-arrow

    Use features that will enhance the quality of your work

Microsoft initiated with spreadsheet program called Multiplan in 1982.But Microsoft lost on popularity to LOTUS 1-2-3. This was when Microsoft launched MS Excel for Mac in 1985, and for Windows in 1987. This Intermediate level of MS Excel 2016 course gives you the extra skills delegates required to be more valuable at their jobs. Also, perform the more important task at their workplace.

MS Excel 2016 is part of the MS Office package that is used commercially everywhere in across the worldwide. Now delegates have access to a step-by-step training that empowers you to become a skilled user of MS Excel. Each concept in this course is well explained in detail with visuals.

Who should take this course

  • Sales Manager
  • Investment Banker
  • New Users Microsoft Excel 2016
  • Users wants to update their skills
  • Auditor
  • Credit Counselor
  • Business Analyst
  • Finance Analyst
  • Engineering Graduates
  • Data Scientist
  • Clerk
  • Market Research Analyst
More

Prerequisites

  • It will be beneficial if delegates have knowledge of the appropriate Windows OS.
More

What Will You Learn

  • Learn to use formulas and functions
  • Create and modify charts
  • Convert, filter, sort and manage lists
  • Adding and modify illustrations in a worksheet
  • Working with tables
  • Analysis of data by using functions and conditional formatting
  • Performing calculations in an Excel worksheet
  • Use conditional formatting and styles
  • Managing the workbooks in MS Excel 2016
  • Perform data visualisation, i.e., represent data by using basic charts
  • Build advanced formulas
  • Organise and analyse datasets
  • Customisation of MS Excel environment
  • Modification of an Excel worksheet
  • Importing, fine-tuning, and sharing Excel data
  • Creating, managing, and launching of macros
  • Create spreadsheets using MS Excel 2016
  • Optimisation of worksheets using graphs, templates, and formulas
  • Design complex formulas by nesting of MS Excel functions
  • Make your decisions using PivotTables, Slicers, and PivotCharts
More

What's included

  Course Overview

MS Excel 2016 can help delegates in organising, calculating, analysing, revising, updating, and presenting your data in ways that will help the senior management to make a decision in your organisation steer you in the right direction. 

Delegates will get skills to analyse large amounts of data, extract useful information from it, and present that information to senior management is the necessity of a successful organisation. This training starts by explaining basic terminologies, tips and tricks of the ribbon, and shortcuts of MS Excel 2016.

It will also teach you about the creation of charts and graphs with data. To handle large datasets available and being build on a nearly continuous basis, as we all know data is becoming more critical and challenging in today's world.

To gain a competitive edge over their competitors, Delegates will need to know how to extract actionable data insights from raw data i.e. when you have any questions; you need to know how to Excel provide you with the answers. It is an aim only to design this course.

 

Uses of excel

More

  Course Content

Overview:

  • Navigate the user interface of MS Excel
  • Use of Excel Commands
  • Build and Save a Workbook
  • Enter a Cell Data

Creating a Microsoft Excel Workbook

  • Start Microsoft Excel
  • Create a Workbook
  • Save a Workbook
  • Status Bar
  • Add and Delete Worksheets
  • Copy and Move Worksheets
  • Change the order of Worksheets
  • Split the Worksheet window
  • Close a Workbook

Advanced Formulas

  • Using Named Ranges in Formulas
  • Naming a Single Cell
  • Naming of a Range of Cells
  • Naming to a Multiple Single Cells Rapidly
  • Use of Formulas That Span Multiple Worksheets
  • IF Function
  • AND/OR Functions
  • SUMIF, AVERAGEIF
  • COUNTIF Functions
  • PMT Function
  • LOOKUP Function
  • Using the VLOOKUP Function
  • HLOOKUP Function
  • UPPER Function
  • LOWER function
  • TRIM Function
  • Using the CONCATENATE Function
  • TRANSPOSE Function
  • PROPER, UPPER, and LOWER Functions
  • LEFT, RIGHT, and MID Functions
  • MID Function
  • Date Functions
  • NOW and TODAY Functions
  • Create Scenarios
  • Utilise the Watch Window
  • Consolidate Data
  • Enable Iterative Calculation
  • Financial Functions

Handling Lists

  • Convert a List into a Table
  • Remove Duplicates from a List
  • Sort Data in a List
  • Filter Data in a List
  • Add Subtotals to a List
  • Group and Ungroup Data in a List

 Handling with Illustrations

  • Working with Clip Art
  • Use Shapes
  • Work with SmartArt

Visualise Your Data

  • Create a Custom Chart Template
  • Insert Charts
  • Adding and Formatting of a Objects
  • Adding a Text Box
  • Creating a Custom Chart Template

Handling Lists

  • Sorting Data
  • Filtering Data
  • Querying Data with Database Functions

Handling Tables

  • Formatting Data in a Table
  • Move between Tables and Ranges
  • Modifying Tables
  • Defining Titles

Advanced Formatting

  • Apply Conditional Formatting
  • Working with Styles
  • Creating and Modifying Templates

Analysing Data

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Use Advanced Conditional Formatting

 

Build Charts in MS Excel 2016

  • Overview to Charts in Excel 2016
  • Inserting Charts in MS Excel and Learn the Various Chart Types
  • Formatting of Excel Charts
  • Creating a Bridge Chart in Excel 2016 - As Easy As It Gets
  • An Easy Way to Create a Treemap
  • Use Sparklines to Show Data Trends

Features New in 2016

  • Overview of Treemap
  • New Charts
  • Sunburst
  • Understand Histogram
  • Study Waterfall
  • Box and Whisker
  • Learn Pareto
More

Shortcuts of Excel

Shortcuts for the MS Excel:

To do this

Press

Close a spreadsheet

Ctrl+W

Open a spreadsheet

Ctrl+O

Go to the Home tab

Alt+H

Save a spreadsheet

Ctrl+S

Copy

Ctrl+C

Paste

Ctrl+V

Undo

Ctrl+Z

Remove cell contents

Delete key

Choose a fill color

Alt+H, H

Cut

Ctrl+X

Go to Insert tab

Alt+N

Bold

Ctrl+B

Center align cell contents

Alt+H, A, then C

Go to Page Layout tab

Alt+P

Go to Data tab

Alt+A

Go to View tab

Alt+W

Format a cell from context menu

Shift+F10, or

Context key

Add borders

Alt+H, B

Delete column

Alt+H, D, then C

Go to Formula tab

Alt+M

 

Vlookup(): It helps to search a value in a table and returns a corresponding value.

                                            

Syntax: = LOOKUP( value, lookup_range, [result_range] )

 

HLOOKUP(): The MS Excel HLOOKUP function performs a search for a value in the top row of the table and returns the value in the same column by index_number.

 

HLOOKUP( value, table, index_number, [approximate_match] )



Microsoft Excel 2016 Intermediate Enquiry

 

Enquire Now


----- OR -------

Reach us at +44 1344 961530 or info@pentagonit.co.uk for more information.

About High Wycombe

High Wycombe , is located in Buckinghamshire, England around 29 milesfrom Charing Cross in London. High Wycombe has a population of 124,475 (as of 2015) and is the second biggest town (after Milton Keynes) in the county of Buckinghamshire. 

 High Wycombe is mostly unparished and a part of the urban area constitutes of the civil parish of Chepping Wycombe . Wycombe   has a traditional em phasis on furniture production. Since the Middle Ages a fair has been held in the High Street.

Wycombe appears to get its name from the river Wye combined with the old English word for a wooded valley, combe. 

Education

In Buckinghamshire  a student has to appear for a 11+ exam to get selected into a  grammar  or a secondary modern school. It boasts of more than 15 Primary Schools, 7 Seccondary Schools, and 4 independent schools.

Located near High Wycombe is the training college – the Amersham & Wycombe College which also has its campuses at Chesham and Amersham. The main campus of Buckinghamshire New University is also in High Wycomb. It is situated on site where the High Wycombe College of Art and Technology was earliier located. It received its university charter in summer 2007.

Industry

Wycombe was once known for furniture making. Even today furniture design form  a part of the university curriculum.   In 1700 AD beech trees were cut down from the The River Wye valley to make furniture. High Wycombe was also known as the home of Harrisons and Sons who priinted postage stamps and banknotes. More new industries in the city include the paper, precision instruments, clothing and plastics. Most of the industrial area lies in the Cressex district, southwest of the city centre. Wycombe's industrial past is reflected on the town's motto "Industry enriches".

More